Versions:
Simba Spark ODBC Driver 2.9.2, released by Simba Technologies Inc. as the second iteration of the connector, is a middleware component designed to open Business Intelligence, analytics, and reporting workflows directly against Apache Hadoop and Spark data lakes. By exposing Spark tables through a standard ODBC interface, the driver lets SQL-speaking applications—from Excel and Power BI to Tableau and custom BI suites—issue queries without learning HiveQL. Internally, the connector transparently rewrites incoming SQL-92 statements into HiveQL, preserving joins, filters, and aggregations, while Spark-aware clients can bypass translation and submit native commands for full distributed execution. Schema discovery is handled automatically: the driver interrogates the Spark catalog and returns metadata that BI tools expect, so tables appear like any relational source. The result is a single, consistent SQL façade on top of parquet, ORC, Avro, or Delta files living in HDFS, S3, or Azure Data Lake, enabling interactive dashboards, parameterized reports, and ad-hoc analysis without moving data into a separate warehouse. Typical use cases include executive dashboards that refresh hourly against streaming Spark jobs, financial month-end reports that join dimensional Hive tables with real-time clickstream data, and data-science notebooks that offload heavy aggregations to the cluster while presenting small result sets locally. As a Database Connectivity sub-category solution, the driver supports Kerberos, LDAP, and SSL for secure enterprise deployments, ships in 32- and 64-bit Windows editions, and is fully compliant with the ODBC 3.8 specification. Simba Spark ODBC Driver is available for free on get.nero.com, with downloads furnished through trusted Windows package sources such as winget, always supplying the latest version and enabling batch installation alongside other applications.
Tags: